﻿CREATE TABLE [KIM].[Person] (
    [PersKey]       INT           IDENTITY (1, 1) NOT NULL,
    [PersTS]        NVARCHAR (18) NULL,
    [Änderung]      NVARCHAR (50) NULL,
    [Zuname]        NVARCHAR (30) NULL,
    [Vorname]       NVARCHAR (20) NULL,
    [Geschlecht]    SMALLINT      DEFAULT ((0)) NULL,
    [TitelKey1]     INT           NULL,
    [TitelKey2]     INT           NULL,
    [Adresse]       NVARCHAR (70) NULL,
    [EPLZ]          INT           DEFAULT ((0)) NULL,
    [Straße]        NVARCHAR (50) NULL,
    [VorwahlKey]    INT           NULL,
    [Mobil]         NVARCHAR (20) NULL,
    [PrivTelefon]   NVARCHAR (25) NULL,
    [PrivFax]       NVARCHAR (25) NULL,
    [MailingSperre] BIT           DEFAULT ((0)) NOT NULL,
    [Notiz]         NTEXT         NULL,
    [Mitarbeiter]   BIT           DEFAULT ((0)) NOT NULL,
    [Kürzel]        NVARCHAR (5)  NULL,
    [eMail]         NVARCHAR (50) NULL,
    CONSTRAINT [aaaaaPerson_PK] PRIMARY KEY NONCLUSTERED ([PersKey] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person';


GO
EXECUTE sp_addextendedproperty @name = N'DateCreated', @value = N'96-03-09 15:06:02', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person';


GO
EXECUTE sp_addextendedproperty @name = N'LastUpdated', @value = N'03-04-17 21:06:50', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person';


GO
EXECUTE sp_addextendedproperty @name = N'MS_OrderByOn', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person';


GO
EXECUTE sp_addextendedproperty @name = N'RecordCount', @value = N'2346', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person';


GO
EXECUTE sp_addextendedproperty @name = N'Updatable', @value = N'True', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'17', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Automatischer Zähler der Personen', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'PersKey', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'4', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'PersKey', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'4', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersKey';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'TimeStamp der PersonenAnlage', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'PersTS', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'18', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'PersTS', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PersTS';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'ÄnderungsDatum der Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Änderung', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'3', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'50', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Änderung', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Änderung';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Zuname', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Zuname', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'4', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'30', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Zuname', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Zuname';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Vorname', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Vorname', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'5', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'20', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Vorname', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Vorname';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Geschlecht', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Geschlecht', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'6', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Geschlecht', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'3', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Geschlecht';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'Null', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Titel', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'TitelKey1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'7', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'4', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'TitelKey1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'4', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey1';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'Null', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Titel', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'TitelKey2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'8', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'4', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'TitelKey2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'4', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'TitelKey2';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Adresse', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Adresse', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'9', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'70', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Adresse', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Adresse';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Eindeutige Postleitzahl', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'EPLZ', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'4', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'EPLZ', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'4', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'EPLZ';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Straße', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Straße', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'11', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'50', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Straße', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Straße';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'Null', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Mobiltelefon Vorwahl', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'VorwahlKey', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'12', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'4', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'VorwahlKey', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'4', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'VorwahlKey';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Mobiltelefon Nummer', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Mobil', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'13', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'20', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Mobil', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mobil';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Private Telefonnummer', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'PrivTelefon', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'14', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'25', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'PrivTelefon', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivTelefon';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Private Faxnummer', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'PrivFax', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'15', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'25', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'PrivFax', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'PrivFax';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Kennzeichen für keine Mailings', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'106', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Format', @value = N'Yes/No', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'MailingSperre', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'16', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'MailingSperre', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'MailingSperre';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Memofeld für Notiz', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Notiz', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'17', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Notiz', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'12', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Notiz';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Kennzeichen für Mitarbeiter', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'106', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Format', @value = N'Yes/No', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Mitarbeiter', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'18', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Mitarbeiter', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Mitarbeiter';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Mitarbeiterkürzel', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Kürzel', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'19', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'5', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Kürzel', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'Kürzel';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Persönliche eMail Adresse', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'eMail', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'20', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'50', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'eMail', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'Person', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'KIM', @level1type = N'TABLE', @level1name = N'Person', @level2type = N'COLUMN', @level2name = N'eMail';

